

/*******************************************************************************
** Bring in all the data
*******************************************************************************/

use "$DATA_OUT/NMDB_ASMB_respondents", clear
svyset [pweight = analysis_weight]


gen EUW_MtM_timeofsurvey = LTV_FHFA_timeofsurvey>=90 & !mi(LTV_FHFA_timeofsurvey)



/*******************************************************************************
** Look at negative equity in the ASMB
*******************************************************************************/

* Compare self-reported negative equity vs. MtM negative equity
* This comparison requires both that the agent report still having the mortgage
* AND the mortgage still existing in administrative data, so condition on both
gen eff_neg_eq_ASMB_stillmort = inlist(x51,3,4,5) if !mi(x51)
svy: tab eff_neg_eq_ASMB_stillmort if !mi(EUW_MtM_timeofsurvey) & x50==1
svy: tab EUW_MtM_timeofsurvey      if !mi(EUW_MtM_timeofsurvey) & x50==1


svy: tab x62j if in_default_sample==1 & foreclosure==1
svy: tab x62j if in_default_sample==1 & foreclosure==1 & second_mortgage_by_survey==0
svy: tab EUW_LTV_FHFA_tract if in_default_sample==1 & foreclosure==1 & second_mortgage_by_survey==0


